You are here: Main Menu > I. Interface Menu > 7. External System > 8. ESI Open AP

ESI Open AP

The ESI Open A/P function is used to export the open vendor balances for all vouchers and voucher adjustments for the current date.

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. When you first enter the ESI Open AP option command options will appear:

Create Open AP ESI(X) – Select Create Open AP ESI(X) to create an open AP ESI file.
Exit – Select Exit to exit and return to the Interface menu

Select Open AP ESI(X).

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

Select no to return to the command options.
Select yes to create a new file with the same name that already exists.

3. The following message will display: "Print report? No/Yes"

Select no to generate export file without a printed detail report.
Select to yes generate the export file and a printed detail report.

Select the appropriate option.

4. The following message will appear: "Create a delimited ASC file? No/Yes."

Select no to create a DBF file only.
Select yes to create a DBF file and an ASC file.

Select the appropriate option.

Two DBF files will be created APMMDDYYYY.dbf and AP_Last.dbf in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The APMMDDYYYY.dbf file is the ESI Open Account Payables balance file for the current date with MMDDYYYY equal to the current date. The AP_Last.dbf is a copy of the current file. If an ASC file was created, the name will be APMMDDYYYY.asc and will be in the Shared \NetYield\Data\Company Name\ESI Outbox folder.

5. If you selected yes to print an ESI open A/P report in Step #3, command options will appear allowing you to print or choose from a set of other print options.

The following information will print:

Vendor – The vendor ID
Name – The vendor name
Vouch – The reference number
Ty – The transaction type
- PO – Purchase order
- VO – Voucher
- AD – Vendor advance
- AJ – Voucher adjustment
Date – The transaction date
Invoice – The vendor invoice number
Buyer – The buyer ID
Trm – The payment terms
Description – The transaction description
Amount – The transaction amount
Total – The total vendor balance

The following fields will be exported from the system:

Field Name	Description	Type
VENDOR	The vendor ID	C 6
VENDORNAME	The vendor name	C 40
VOUCHER	The transaction number	C 5
TYPE	The transaction type: PO – Purchase order VO – Voucher AD – Vendor advance AJ – Voucher adjustment	C 2
DATE	The transaction date	D 8
INVOICE	The vendor invoice number	C 10
BUYER	The buyer ID	C 10
TERMS	The payment terms	C 2
DESC	The transaction description	C 30
AMOUNT	The transaction amount	N 10, 2
OLD_VENDOR	The old vendor ID	C 6
VENDCORPID	The vendor's corporate ID	C 8

Security Required : Payables - Payable Reports